Microsoft Power BI is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life.
With Power BI Desktop, you can:
The Power BI Desktop makes discovering data easy. You can import data from a wide variety of data sources. After you connect to a data source, you can shape the data to match your analysis and reporting needs.
When you import two or more tables, oftentimes you’ll need to create relationships between those tables. The Power BI Desktop includes the Manage Relationships dialog and the Relationships view, where you can use Autodetect to let the Power BI Desktop find and create any relationships, or you can create them yourself. You can also very easily create your own measures and calculations or customize data formats and categories to enrich your data for additional insights.
The Power BI Desktop includes the Report View. Select the fields you want, add filters, choose from dozens of visualizations, format your reports with custom colors, gradients and several other options. The Report View gives you the same great report and visualizations tools just like when creating a report on PowerBI.com
With the Power BI Desktop, you can save your work as a Power BI Desktop file. Power BI Desktop files have a .pbix extension.
You can upload the reports you created and saved in the Desktop to your Power BI site. You can also publish them to Power BI right from Power BI Desktop.
– Connect, import, shape, and transform data for business intelligence (BI)
– Visualize data, author reports, and schedule automated refresh of your reports
– Create and share dashboards based on reports in Power BI desktop and Excel
– Use natural language queries
– Create real-time dashboards
Getting Data
– Overview of Power BI Desktop
– Getting Started with Power BI Desktop
– Connect to Data Sources in Power BI Desktop
– Clean and Transform Your Data with the Query Editor
– More Advanced Data Sources and Transformation
– Cleaning Irregularly Formatted Data
Modeling
– Introduction to Modeling Your Data
– How to Manage Your Data Relationships
– Create Calculated Columns
– Optimizing Data Models
– Create Calculated Measures
– Explore your time-based data
Visualizations
– Introduction to Visuals in Power BI
– Create and Customize Simple Visualizations
– Combination Charts
– Slicers
– Map visualizations
– Matrixes and tables
– Scatter Charts
– Waterfall and funnel charts
– Gauges and single-number cards
– Modify colors in charts and visuals
– Shapes, text boxes, and images
– Page Layout and Formatting
– Duplicate a Report Page
– Show Categories with no Data
– Z-order
– Visual hierarchies and drill-down
Publishing and Sharing
– Introduction to the Power BI Service
– Publish Power BI Desktop reports
– Introduction to Content Packs, Security, and Groups
– Print and export dashboards and reports
– Quick Insights in Power BI
– Create and Configure a Dashboard
– Share Dashboards with your organization
