microsoft excel data analysis and dashboard reporting

The Context for Calculated Columnsĭefault Summarization Explicit Measures Measures and Context Defining Context Within a Measure Time Analytics Row-by-Row Calculations The FILTER() Functionģ. Chapter 12 Measures and Calculated Columns 1. Chapter 11 Creating a Tabular Model in Power BI 1. Transformations on the Query Editor Add Column Tabģ. Transformations on the Query Editor Transform Tab 4. Transformations on the Query Editor Home Tab 3. Chapter 10 Power BI Transformation Reference 1. Creating an Intermediate Table from a Data Source 2. The Advanced Editor and the Power Query Formula Language 4. Repeating and Changing the Data Import 1.

Transforming Data During the Data Import 1. Custom Visualizations from R and Python 3.

Custom Visualizations from the Marketplace 2. Synchronizing SlicersĬustom Tooltips Bookmarks Selection Pane Buttonsģ. Chapter 8 Advanced Interactivity and Custom Visualizations 1. Conditional Formatting Advanced Controls Dialog Box 2. Pie Chart, Donut Chart, Treemap, and Maps 8. Maximum Miniatures Manufacturing Our First Report Page Text-based Visualizations Graphical Visualizationsģ. Reports Dashboards Workbooks Datasets Dataflowsģ. Chapter 5 Using the Power BI Service () 1. 4.ĭrill Down and Drillthrough Buttons Bookmarks Additional Data Interactionsģ. Changing the Data with Slicers and Filters 1. Opening the Report/Preparing the EnvironmentĢ. Chapter 4 Using Power BI Visualizations 1. Power BI Desktop Optimizations Power BI Updates Microsoft On-premises Data Gateway What Does the Data Have to Say?Ģ. Power BI Desktop The Power BI Service The Power BI Report Server The Power BI Mobile App Take an Iterative Implementation Approach Utilize a Data Warehouse/Data Mart Cleanse and Validate During Data Gathering Create User-Friendly Data Models Publish Latency Provide Training and Support Use the Right Tool for the Job Establish Standards and Limitsĩ. 6.ĭesire Realistic Expectations Ongoing Care and Feeding Well-Defined KPIs Actionable KPIs Reliable Sources of Dataģ. Chapter 2 Successful Self-Service Analytics 1. How to Succeed at Self-Service AnalyticsĢ. Information on Power BI New Features and EnhancementsĤ. 4.Ĭonsuming Power BI Reports Power BI as a Data Visualization Tool Power BI as a Modeling Tool Power BI as a Data Warehouse/Data Martģ. Cover Title Page Copyright Page Dedication Contents at a Glance Contents Acknowledgments Part I Understanding Business Intelligence and Power BI 1.

Microsoft excel data analysis and dashboard reporting