.
Power BI
About Course
Power BI is a set of tools and services designed to transform diverse data sources into clear, engaging, and interactive insights. Whether your data is stored in an Excel spreadsheet or a mix of cloud-based and on-premises hybrid data warehouses, Power BI allows you to effortlessly connect to your data, visualize key information, and share these insights with specific individuals or a broader audience. Power BI’s dashboard is user-friendly, catering to business professionals with diverse data expertise. It empowers users to report and visualize data in various styles such as graphs, maps, charts, scatter plots, and more. Additionally, the “AI Insights” feature employs artificial intelligence to uncover valuable insights within datasets, enhancing the tool’s analytical capabilities. Power BI consists of various interconnected applications, such as Power BI Desktop, Pro, Premium, Mobile, Embedded, and Report Server. While some of these applications are available for free, opting for pro and premium subscriptions unlocks enhanced analytics features. Moreover, Power BI is a key component of Microsoft’s Power Platform, which encompasses Power Apps, Power Pages, Power Automate, and Power Virtual Agents. These “low-code tools” are designed to assist businesses in analyzing and visualizing data, crafting business solutions, automating processes, and developing no-code chatbots.
Course Content
INTRODUCTION TO POWER BI
LOAD DATA FROM EXCEL, CSV & WEB
ENTER DATA FROM SQL & TABLE
POWER QUERY HOME TAB
POWER QUERY TRANSFORM TAB
POWER QUERY ADD COLUMN & VIEW TAB
POWER QUERY GROUP BY
POWER QUERY PARAMETER
- POWER QUERY FUNCTIONS
ABOUT SCHEMA
POWER QUERY MODELING PREP
POWER QUERY MODELING STAR
POWER QUERY MODELING SNOW
POWER BI TEMPLATE
POWER BI VISUALS
DEVELOPMENT : INTRO
DEVELOPMENT : CARD & MEASURE
DEVELOPMENT : CLUSTERED BAR 1
DEVELOPMENT : CLUSTERED BAR 2
DEVELOPMENT : CLUSTERED BAR 3 & MAP
DEVELOPMENT : PIE DONUT Q&A
DEVELOPMENT : BOOKMARKS
DEVELOPMENT : FILTERS SLICERS CONDITIONAL FORMATING
DEVELOPMENT : DRILL THROUGH
DEVELOPMENT : CUSTOM TOOLTIP
DEVELOPMENT : INTERACTIONS
REPORT : PREP 1
REPORT : PREP 2
REPORT : PREP 3
REPORT : FINAL
REPORT : FORMATTING 1 TIPS
REPORT : FORMATTING 2 THEME
REPORT : FORMATTING 3 FINAL
POWER BI SERVICE INTRODUCTION
POWER BI SERVICE MISC FEATURES
NEW UPDATES BY MICROSOFT