Power BI Desktop for Business Analytics is a 12-hour training course by IT Genius Institute. Business decisions today depend on both the accuracy and the speed of data. Organizations that can turn massive raw data into business insight faster gain a…
Training schedule
No public rounds are open right now — register your interest and we will contact you when the next round opens, or request an in-house session for your team.
Business decisions today depend on both the accuracy and the speed of data. Organizations that can turn massive raw data into business insight faster gain a competitive edge. Microsoft Power BI is a business intelligence and analytics platform consistently ranked a market leader, able to connect to diverse data sources, shape and transform data, build a data model, calculate with the DAX language, and present results as beautiful, interactive reports viewable on any platform - PC, tablet and mobile. This course is designed for those who want to analyze their organization's
existing data for business themselves, starting from the fundamentals of business intelligence and the star schema, connecting to data from files, databases and websites, cleaning and transforming data with Power Query, designing table relationships and building calculations with DAX, choosing the right visualizations for business questions, and publishing reports to the Power BI Service to share with the team, set automatic data refresh and view on mobile devices. Every topic comes with a hands-on workshop using sample business datasets so learners can apply it to their real organizational data immediately.
Objectives
Understand business intelligence, data analytics and how Power BI Desktop works, including the star schema data structure
Connect and import data from diverse sources - files, databases, cloud and websites
Prepare, clean and transform data (ETL) efficiently with Power Query, with a basic understanding of the M language
Design and manage data-model relationships correctly
Build calculations with DAX - calculated columns, measures and calculated tables - including basic time intelligence
Choose the right visualizations for business questions and build interactive dashboards with a mobile layout
Publish reports to the Power BI Service, share with others, set automatic data refresh and configure data alerts
Understand licensing, the Power BI Gateway and how to roll out Power BI in the organization
Who this course is for
Data analysts and business analysts
Chief data officers and directors, plus managers and team leads who use data to make decisions
Sales, marketing, accounting, finance, inventory and HR staff who produce regular reports
People who already use Microsoft Excel for reporting and want to move up to interactive dashboards
Anyone who wants to start a career in data analytics and business intelligence
Prerequisites
Comfortable using Windows and the internet
Basic experience with tabular data, understanding rows, columns and data types, and basic data analysis
Able to use PivotTables and create charts in Microsoft Excel
No programming or database background required
Curriculum
Day 1: Power BI Fundamentals, Data Sources and Data Preparation with Power Query
Section 1: Getting to Know Microsoft Power BI
An overview of Power BI and its place in the Microsoft Power Platform, the role of data analytics and the business intelligence concept
How Power BI works (Connect, Transform, Model, Visualize, Share), the components Power BI Desktop, Service and Mobile, and licensing (Free, Pro, PPU, Premium)
Downloading, installing and configuring Power BI Desktop, the working views (Report, Table, Model View) and the star schema (fact and dimension tables)
Workshop: build your first report with Power BI Desktop from the sample data
Section 2: Data Sources for Power BI Desktop
Understanding data sources and connection modes: Import, DirectQuery and Live Connection
Using Excel, Text/CSV, Folder (auto-combining all files), SQL Server, Azure SQL Database, SSAS, Enter Data, and importing from websites and SaaS services
Case study: examining exchange-rate data from the Bank of Thailand website
Workshop: connect data from multiple sources into a single report file
Section 3: Data Transformation with Power Query
The ETL concept, the Power Query Editor and Applied Steps, viewing data quality (Column Quality, Distribution, Profile) and adjusting data types by locale (Buddhist and Gregorian years)
Shaping data: Remove Row/Column, Remove Duplicate and Unpivot Columns, plus data cleansing: Trim, Clean, casing, and Replace Values/Errors
Splitting and merging columns, combining data with Append and Merge Query (join types), creating custom/conditional columns and Group By
Getting to know the M language and Advanced Editor, using parameters and groups, plus a workshop: turn unready sales data into an analysis-ready table
Day 2: Data Model, DAX, Building Dashboards and Publishing with the Power BI Service
Section 4: Working with the Data Model in Power BI Desktop
The data-model concept, why fact and dimension tables are separated, and managing relationships, cross-filter direction and cardinality
Formatting fields (format, currency, percentage), setting implicit measures (summarization) and data categories for maps, links and images
Building hierarchies for drill-down, setting Sort by Column (e.g. months in calendar order) and hiding unnecessary fields
Workshop: design a star-schema data model from the tables prepared on Day 1
Section 5: Calculations with DAX (Data Analysis Expressions)
Getting started with DAX, how it differs from Excel formulas, syntax, table/column references and the basics of row context and filter context
Creating calculated columns and explicit measures, aggregation functions (SUM, AVERAGE, COUNT, DISTINCTCOUNT), logical functions (IF, SWITCH) and CALCULATE
Relationship functions (RELATED, RELATEDTABLE), building a Date Table and Mark as Date Table, plus basic time intelligence (running totals, prior-year comparison) and calculated tables
Case study: computing product age and age bands, plus a workshop: build a set of measures for business KPIs such as sales, profit, margin and growth
Section 6: Building Dashboards with Power BI Visualizations
Choosing the right visualization for the data: Card, KPI, Table & Matrix (conditional formatting), Bar/Column, Pie/Donut, Treemap, Combo, Map, Scatter and Waterfall charts
Layout, color themes and readable dashboard design principles, and building a mobile report with Mobile Layout
Case study: a Sales Performance Report shown on a mobile device, plus a workshop: design and build a complete interactive sales dashboard
Section 7: Using the Power BI Service
Publishing reports to the Service, the Workspace, Semantic Model, Report and Dashboard structure, and Publish to Web with security precautions
Building a dashboard with Pin Visual, natural-language queries (Q&A), sharing reports (Share, App, Workspace Role) and exporting to PDF, PowerPoint and Excel
Setting up a subscription to email reports, configuring data alerts, and viewing reports on Power BI Mobile
Getting to know the Power BI Gateway and setting up scheduled refresh, plus a workshop: publish a dashboard, share it with teammates, set a data alert and view it on Power BI Mobile
Frequently asked questions
Who is Power BI Desktop for Business Analytics for, and what background is needed?
Built for Data analysts and business analysts · Chief data officers and directors, plus managers and team leads who use data to make decisions · Sales, marketing, accounting, finance, inventory and HR staff who produce regular reports Background you should have: Comfortable using Windows and the internet · Basic experience with tabular data, understanding rows, columns and data types, and basic data analysis Not sure the fit is right? Talk to our team on LINE @itgenius or call 02-570-8449.
How much does Power BI Desktop for Business Analytics cost and how long does it run?
THB 6,900 (currently THB 6,210 on promotion). The course runs 12 hours. The fee covers course materials, lunch and refreshments throughout. Pay by bank transfer to the company account, confirm it on our payment page, and we can issue the receipt or tax invoice in your company's name.
Do I get a certificate?
Yes. Everyone who completes the course receives a Certificate of Completion from IT Genius Institute. Each certificate carries its own number, and anyone holding that number can verify it online on our certificate page, so you can add it to your portfolio or pass it to HR as evidence of training.
Where does the training take place, and is there an online option?
You can attend onsite at IT Genius Institute or arrange to join online, and we also run it as a private in-house session for your team. Ask about dates and venues on LINE @itgenius or call 02-570-8449.
What if I fall behind or miss a session — can I retake it?
Yes. You may retake the same course free of charge in a later round, under the institute's conditions. Tell our team which course and round you attended, and we will check it and offer you the rounds that still have seats. Ask us on LINE @itgenius or call 02-570-8449.
How do I enrol, or request a quotation for my company?
Enrol online with the registration form on this page. You can register several attendees at once and enter your tax ID and billing address for the tax invoice. Or request a company quotation straight from the quote button. For anything else call 02-570-8449 or reach us on LINE @itgenius.
Microsoft Power BI Desktop เป็นเครื่องมือที่ใช้ในการวิเคราะห์ข้อมูลขนาดใหญ่ ใช้วิเคราะห์ข้อมูลเชิงลึก รายงานผลแบบ Interactive ซึ่งเป็นโปรแกรมชั้นนำด้านการสืบค้นข้อมูลและสร้างแบบจำลองในวงการอุตสาหกรรม สามารถสร้างและเผยแพร่รายงานไปที่ Power BI ได้…
