Microsoft Power BI Training in Columbus, OH, United States

Immersive learning for Data Analysis with Microsoft Power BI

  • Extract and share meaningful insights from data  
  • Master Data Cleaning, Data Visualization, Data Sharing, Data Collaboration 
  • Immersive learning with real-world projects, hands-on exercises, assessments, more 
  • 250,000 + Professionals trained
  • 250 + Workshops every month
  • 100 + Countries and counting

Become a skilled Data Analyst with the Microsoft Power BI certification

Build in-demand data analysis skills with Microsoft Power BI—a business intelligence suite designed to simplify the path from data to insights. Start with the general end-to-end workflow using Power BI and equip yourself with the tactics for loading and working with your data to enable analysis. You’ll learn powerful techniques specialized to Power BI.

..... Read more
Read less

Highlights

  • 30 Hours of Live Instructor-Led Sessions

  • 95 Hours of On-Demand Learning

  • 110+ Hands-on Exercises

  • 20 Auto-Graded Assessments, 120+ Quizzes

  • 1 Capstone Project, 6 Assignments

  • Lifetime Access to Courseware

Power BI skills are highly sought after

The world is one big data problem as Andrew McAfee, co-director of the MIT Initiative on the Digital Economy puts it. Those with the skills to navigate large amounts of data and extract meaningful insights are in high demand. Skilled business analysts with proficiency in Power BI skills are particularly sought after with Power BI recognized as a leader in Analytics and Enterprise BI platforms for the twelfth consecutive year.  

..... Read more
Read less

Power ahead in your career with industry-ready Business Analytics skills

Contact Learning Advisor

Who should attend the Power BI course online?

Aspiring Data Analysts

Excel users

Tableau users looking to migrate to Power BI

Professionals looking to automate Excel-intensive work

Professionals seeking to expand skills beyond Excel

Microsoft Power BI Course Schedule

Can't find the batch you're looking for?

Request a Batch

Microsoft Power BI Certification Training Curriculum

Download Curriculum
Video preview 1.

Learning Objectives 

 In this introductory module you will learn the basics of Power BI and how to install it on your machine.

  • Introduction to Power BI 
  • Download, Install and Update Features in Power BI 

Learning Objectives 

This module helps you learn the step-by-step process involved in connecting your data source in MS Excel to Power BI.  

Topics

Connecting to Excel 

Learning Objectives

Power BI introduces you to a range of charts to simplify data and present it in new and insightful ways.

Topics
  • Basic Charts in Power BI Desktop 
  • Column Chart in Power BI  
  • Stacked Column Chart in Power BI  
  • Pie Chart in Power BI  
  • Donut Chart in Power BI  
  • Funnel Chart in Power BI  
  • Ribbon Chart 
  • Include and Exclude 
  • Export data from Visual 
Video preview 4.

Learning Objectives

Learn how to create maps using Power Bl. Enhance charts by plotting data on a map and reveal new insights. 

  • Maps in Power BI  
  • Creating a Map in Power BI  
  • Filled Map 
  • Map with Pie Chart 
  • Formatting in Map 
  • Change Background in Map 
  • Map of India in Power BI 
  • Map of Australia in Power BI

Learning Objectives

Create and manipulate data using Tables. Use matrix to tabulate and show data in a useful visualization.

Topics
  • Table and Matrix in Power BI  
  • Creating a Table in Power BI  
  • Formatting a Table 
  • Conditional Formatting in Table 
  • Aggregation in Table 
  • Matrix in Power BI  
  • Conditional Formatting in Matrix  
  • Hierarchies in Matrix 
  • Sub-Total and Total in Matrix 
  • Number Formatting in Table 
Video preview 6.

Learning Objectives 

Learn to make more charts to show data in a more innovative manner.  

  • Other Charts in Power BI  
  • Line Chart in Power BI  
  • Drill Down in Line Chart 
  • Area Chart in Power BI  
  • Line vs Column Chart in Power BI  
  • Scatter Plot in Power BI  
  • Waterfall Chart in Power BI  
  • TreeMap in Power BI  
  • Gauge Chart in Power BI 
Video preview 7.

Learning Objectives   

Use different types of cards using Card Visualization. Also learn to use different types of filters to focus on the data that really matters to you. 

  • Cards and Filters in Power BI  
  • Number Card 
  • Text Card 
  • Formatting of Text Card 
  • Date Card and (Relative Filtering) 
  • Multi-Row Card 
  • Filter on Visual 
  • Filter on This Page 
  • Filter on All Pages 
  • Drill through in Power BI 
Video preview 8.

Learning Objectives

Explore the different types of Slicers in Power BI. Learn how and where to use them.

  • Slicers in Power BI  
  • Text Slicers in Power BI  
  • Formatting a Text Slicer 
  • Date Slicers in Power BI 
  • Formatting a Date Slicer 
  • Number Slicers in Power BI 
Video preview 9.

Learning Objectives

There are even more charts Power BI has to offer. Learn how to animate bar charts, and show infographics.

  • Advanced Charts in Power BI  
  • Animated Bar Chart Race 
  • Drill down donut Chart 
  • Drill down Column chart 
  • Word Cloud in Power BI  
  • Sankey Chart in Power BI  
  • Infographic in Power BI  
  • Play Axis in Power BI  
  • Scroller in Power BI  
  • Sunburst Chart in Power BI  
  • Histogram in Power BI 
Video preview 10.

Learning Objectives

Customize your reports and charts by adding images, shapes, links and buttons to it. Learn how to insert and use objects. 

  • Insert Image in Power BI  
  • Insert Text in Power BI  
  • Insert Shapes in Power BI  
  • Insert Buttons in Power BI  
  • Web URL Action in Power BI  
  • Page Navigation Action in Power BI  
  • Bookmark Action in Power BI 
  • Drill through Action in Power BI
Video preview 11.

Learning Objectives 

Get even more out of Power BI by understanding it’s advanced features like sharing and subscribing.

  • Create a Superstore Report in Power BI 
  • Create an Account on Power BI Service 
  • Publish Report to Power BI Service Account 
  • Export Power BI Report to PPT, PDF or PBIX
  • Comment, Share and Subscribe to Power BI Report 
  • Create a Dashboard in Power BI Service 
  • Problem in Power BI Dashboard and its Solution 
  • Automatic Refresh in Power BI Using Gateway 
Video preview 12.

Learning Objectives 

Learn how to use the different text functions through Power Query.

  • Text Functions in Power Query (Power BI) 
  • Merge Columns in Power Query (Power BI) 
  • Split and Trim in Power Query (Power BI) 
  • Upper, Lower and ProperCase in Power Query (Power BI) 
  • Prefix and Suffix in Power Query (Power BI) 
  • Left, Right and Mid Functions in Power Query (Power BI) 
  • Extract Text with Delimiters
Video preview 13.

Learning Objectives 

Learn how to use the different date functions through Power Query.  

  • Date Functions in Power Query (Power BI) 
  • Year, Quarter, Month and Day Functions in Power Query (Power BI) 
  • Find Difference between Dates in Power Query (Power BI) 
  • Month and Day Name in Power Query (Power BI) 
  • Day, Week of Month, Year in Power Query (Power BI) 
  • Extract Date, Time in Power Query (Power BI) 
  • Calculate Age in Power Query (Power BI) 
  • Day of Year, Quarter, Month in Power Query (Power BI) 

Learning Objectives 

Learn how to use the different number functions through Power Query.

Topics
  • Number Functions in Power Query (Power BI) 
  • Basic Number Functions in Power Query (Power BI) 
  • Percentage, Percent Of, Module in Power Query (Power BI) 
  • Round Functions in Power Query (Power BI) 
  • IsEven, IsODD, Sign in Power Query (Power BI)

Learning Objectives

Learn how to use the distinct ways to append files using Power Query.

Topics
  • Append Multiple CSV Files in a Folder in Power Query (Power BI) 
  • Append Multiple Excel Sheets, Tables in Power Query (Power BI) 
  • Append Excel Sheets or Tables with Different Columns in Power BI 
  • Append Multiple Excel Files from a Folder in Power BI 
  • Append Different Data Sources in Power BI

Learning Objectives 

Learn how to use the distinct ways to merge files using Power Query.

Topics
  • Merge Files and Tables in Power BI 
  • Merge Sheets or Tables in Power Query (Power BI) 
  • Merge Data from Multiple Excel Files or Workbooks in Power BI 
  • Merge Data from Different Data Sources in Power Query (Power BI) 
  • Merge Data having Multiple Criteria in Power BI 

Learning Objectives 

Explore how to use conditions to manipulate columns using Power Query.

  • Conditional Column and Column from Example in Power BI 
  • Column from Examples in Power BI - Split Text 
  • Column from Examples in Power BI - Merge Columns 
  • Column from Examples in Power BI - Date 
  • Column from Examples in Power BI - Alphanumeric 
  • Conditional Column in Power BI - One Column 
  • Conditional Column in Power BI - Two columns 
  • Conditional Column in Power BI - Compare two columns 
  • Conditional Column in Power BI - on Dates 

Learning Objectives 

Learn important concepts in Power Query to explore a few unique functions.

  • Very Important Topics in Power Query (Power BI) 
  • Fill Down in Power BI 
  • Grouping in Power Query (Power BI) 
  • Transpose in Power Query (Power BI) 
  • Unpivot In Power Query (Power BI) 
  • Data Types in Power Query (Power BI) 
  • Replace Errors and Values in Power Query (Power BI) 
  • Keep and Remove Rows in Power Query (Power BI) 
  • Add, Remove and Goto Columns in Power Query (Power BI)
Video preview 19.

Learning Objectives 

Use M language to prepare data before loading into Power BI.

  • M Language in Power Query 
  • Introduction to M Language 
  • IsIn Date Functions in M Language - Power BI 
  • Add and Subtract Date M Functions in Power BI 
  • Basic Date M Functions in Power BI 
  • Basic Text M Functions in Power BI 
  • Simple M Code in Power BI
  • Trick to Get All 900+ M Functions in Power BI
20.

Get a chance to work on the real-world scenario of Wholesaler Business in the field of visualization. In this capstone, you’ll get to use end-to-end Power BI and strengthen the Pillars of Data Extraction all the way to Data Visualization and Automation.

After the capstone, you’ll be able to distinguish between important KPIs and Power of Visualization to extract meaningful information out of Data.

Frequently Asked Questions on the Power BI Online Training

Microsoft Power BI Course

The Microsoft Power BI course has been thoughtfully designed to make you a skilled data analyst ready to take on significant roles in top companies. At the end of the course, you will be able to: 

  • Improve Data Integrity by Cleaning Data 
  • Learn Data Extraction and Data Visualization 
  • Automate manual work on Excel 
  • Create Interactive Reports and Dashboards 

The program takes you on a learning journey from the absolute basics and concepts of Power BI, All the way up to using advanced features. 

Yes, our Microsoft Power BI course is designed to give you flexibility to skill up as per your convenience. We have both weekday and weekend batches to accommodate your current job and have interesting projects that will keep you practicing as you learn. The course is delivered both in a Blended Learning and Self-Paced mode so that you can balance your work and learning as per your schedule.  

In addition to training hours, we recommend spending about 2 hours per day every day of the training, to study, practice and achieve optimal benefits from the course.

The Microsoft Power BI course is well suited for Aspiring data analysts, or people looking to automate work in excel or individuals wanting to migrate to Power BI from Excel or Tableau.

Basic knowledge of Excel functions—Sum, Avg, Min, Max and Vlookup—and working knowledge of pivot tables, pivot charts and simple charts is required to take this course.

To attend the Microsoft Power BI training program, the basic software and system requirements are as mentioned below 

Software Requirements 

  • Microsoft Power BI Desktop 
  • Microsoft Excel 2016 version or latest 

System Requirements 

  • Windows 8.1 / Windows Server 2012 R2, or later. 
  • .NET 4.6.2 or later. 
  • Internet Explorer 11 or later. 
  • Memory (RAM): At least 2 GB available, 4 GB or more recommended. 
  • Display: At least 1440 x 900 or 1600 x 900 (16:9) required 

Yes, a basic understanding of Excel functions and concepts like Pivot tables and simple charts will be required to take up the Microsoft Power BI training. 

Yes! Upon passing the Microsoft Power BI course, you will receive a signed certificate of completion from KnowledgeHut. Thousands of KnowledgeHut alumni use their course certificate to demonstrate skills to employers and their networks.  

More than the certificate, however, you will get to showcase your newly acquired Power BI skills by working on real-world projects and adding these to your portfolio. KnowledgeHut’s Microsoft Power BI course is well-regarded by industry experts, who contribute to our curriculum and use our tech programs to train their own teams. 

One of the key features of our course is the opportunity to work on fun micro-projects during the program followed by a production grade capstone project at the end. This course is full of fun examples throughout the course of instruction, followed by even more exercises that you get to work with on our web-based interactive analysis environment. 

Individuals can try out KnowledgeHut’s immersive learning experience using a free trial. You have 14 days or 30% access, whichever comes first, to the course you’ve started the free trial for. This includes all the features of the platform, including on-demand videos, auto-graded assessments, interactive eBooks, recall quizzes, and advanced learning insights. 

Workshop Experience

The Microsoft Power BI course at KnowledgeHut is delivered through PRISM, our immersive learning experience platform, via two modes of delivery: 

Blended learning: 

  • Get the best of both worlds with live and interactive instructor-led training sessions along with the convenience and flexibility of self-paced learning. 
  • Listen, learn, ask questions, and get all your doubts clarified from your instructor, who is an experienced practitioner. 
  • You also get to collaborate and learn from the experience of your peers in real-world simulations and activities. 

On-Demand Self-Learning: 

Learn conveniently at your own pace, whenever and wherever you choose. Spend as much time as you need to on areas or topics that you find most difficult, pausing and replaying relevant segments of video as often as you need to. Benefit from the limitless educational possibility that comes with lifetime access. The entire courseware and all the features of our immersive learning experience platform will remain at your fingertips whenever you wish to refresh concepts and clear your doubts. 

The Microsoft Power BI course is delivered by leading practitioners who bring current best practices and case studies from their experience to the live and interactive training sessions. The instructors are industry-recognized experts with more than 7 years of experience in Power BI. 

Not only will they impart knowledge of the fundamentals and advanced concepts, but they will also provide end-to-end mentorship and hands-on guidance on the real-world projects. 

Our workshops are structured in three parts – pre-workshop, workshop, and post-workshop – to provide you with a completely immersive learning experience. This tried and tested workshop structure has worked well with thousands of engineers we’ve helped upskill over the years. 

  • Pre-workshop: Take our diagnostic assessment before the workshop and benchmark your skill levels at the start of the course. This allows you to map and demonstrate your skills learning progression as you reach the end of the course. 
  • Workshop: Join the live and interactive instructor-led sessions right from within PRISM, our immersive learning experience platform with a state-of-the-art intelligent coding environment. Experience immersive learning with live instructor-led sessions, guided hands-on exercises, assignments, auto-graded assessments, recall quizzes, real-world projects, and much more. 
  • Post-workshop: We don’t just impart skills but also want to make sure that you implement them post the course. To help you with this, we are always in touch with you through newsletters, webinars, or next version training. Some post-training deliverables lined up for you are: 
    • Project assistance with mentorship 
    • Access to alumni network 
    • Continued social learning with discussion forums, group messenger, and one-to-one messaging. 
    • Additional workshops on advanced level concepts 
    • Regular emails, blogs, articles, emails, newsletters, tutorials, and other such rich informational content. 

A unique feature of our Microsoft Power BI course is the highly engaging, immersive learning you experience. You get to learn, practice, assess, get insights on your learning, and personalize your learning journey. 

  • LEARN: Engaging self-learning videos, smart flashcards, interactive eBooks and recall quizzes help reinforce your learning. You also get to maximize your learning potential with collaborative social learning via discussion forums and group and one-to-one messaging. 
  • PRACTICE: Guided hands-on exercises will help you gain confidence and get productive from day one. 
  • ASSESS: Assess your skills at every stage with a variety of questions, completely auto-graded by the system. Assignments and projects give you micro “work-like” experiences. Test your subject matter comprehension through diagnostic, module level, and final assessments. 
  • GET INSIGHTS: Based on your performance in the assessments, assignments, and projects, you gain deep insights on your progress, which help you identify areas you are good at and where you need to improve. All you need to do is follow recommendations and enhance your skill proficiency from where you are to where you want to get. 

PRISM is KnowledgeHut’s state-of-the-art learning experience platform. PRISM is designed to provide a highly engaging, immersive learning experience with you at the center of the learning. 

PRISM supports all types of courses, including on-demand self-paced learning, blended learning, and live virtual classes. Here are some key features of the platform: 

  1. Learners can watch videos, join live sessions directly, and even book 1 - 1 mentoring sessions with expert instructors easily, using a single dashboard. 
  2. Integrated Practice Environment runs directly in the user’s browser, offering a complete set of development tools to allow learners to practice what they’ve learned.  
  3. Feature-rich videos with detailed explanations are augmented by flashcards, interactive e-reading content, and quick recall quizzes designed to strategically reinforce learning.  
  4. Diagnostic, module-level, and final assessments give learners valuable insights, allowing them to map and demonstrate their skills learning progression through the course. 
  5. Learners get micro work-like experiences from auto-graded projects that help them learn on the job, much like analysts in leading companies.  
  6. Social Learning tools include a discussion board that features questions posted by other learners on the system and responses by both mentors and learners. Additionally, one-to-one and group messaging are also available. 
  7. Comprehensive reports give both organizations and learners a deep and thorough insight into skills progression. 

Our Microsoft Power BI workshops are currently held online and anyone with a stable internet from anywhere across the world can benefit from this to skill up in PowerBI. 

Schedules for our upcoming workshops in Microsoft Power BI can be found here

You will receive a registration link from PRISM to your e-mail id. You will have to set your password, log in to our Immersive Learning Experience platform and start your learning journey. 

You will have lifetime access to the entire Self-Paced Learning material including on-demand videos, assessments, quizzes, ebooks/case studies and more.

You can attempt the recall quizzes any number of times. Assessments can be taken twice.

We currently use the Zoom platform for video conferencing and will soon be adding more integrations like Webex and Microsoft Teams. However, all the sessions and the recordings will be available right from within our learning platform. Learners will receive instructions through PRISM notifications and will not need to wait for any external notifications or links. 

Yes, there are other participants who actively participate in the class remotely.  They can attend online training from office, home, or any other suitable place. 

In case of any queries, our support team is available to you 24/7 via the Help and Support section on PRISM. You can also reach out to your workshop manager on your workshop group messenger. 

If you miss a class, you can access the class recordings from PRISM at any time. At the beginning of every session, there will also be a 10-12 minute recapitulation of the previous class. 

Should you have any more questions, please raise a ticket on PRISM or email us on support@knowledgehut.com and we will be happy to get back to you. 

The KnowledgeHut Edge

Immersive Learning

Learn, practice, assess, get insights on your learning, and acquire immediately applicable data analysis skills.

Hands-On Practice

Gain confidence and get productive from day one with guided hands-on exercises.

Maximized Learning

Engaging self-learning videos, smart flashcards, interactive e-books, recall quizzes, more.

Auto-Graded Assessments

Diagnostic assessments, module-end assessments, and a final assessment at the end of the program.

Advanced Learner Insights

Gain deep insights on your progress and identify areas you are good at and where you need to improve.

Exclusive Post-Training Sessions

Six months of post-training mentor guidance to overcome challenges in your Data Science career.

Prerequisites

Prerequisites for the Power BI certification

  • Basic knowledge of Excel functions—Sum, Avg, Min, Max and Vlookup
  • Working knowledge of pivot tables, pivot charts and simple charts

What you’ll learn in the Power BI training

Remove Duplicate Records

Learn how to remove duplicate records using Power BI Query Editor.

Automation

Automate tasks using Data Aggregation, Custom Tasks and more.

Speeding up work

Learn all the distinct ways in which you can speed up your tasks and save time.

Reports and Dashboards

Learn to create interactive reports and dashboards that are easy to understand.

Auto emailed Reports

Learn how to schedule a Power BI Report that can be exported and mailed.

Skills you’ll gain in the Microsoft Power BI training

Data cleansing

Creating charts, maps, tables

Aggregation, Matrix, Conditional Formatting

Scatter Plots, Waterfall Charts, TreeMaps

Using Gauge Charts, Cards, Filters

Using Drillthrough, Slicers, Advanced Charts

Using Time and Date Functions, Number Functions

Merging Data, using M Language

Managing custom reporting solutions

Creating reports and dashboards

Scheduling automated email reports

Creating, formatting interactive visualizations

Transform Your Workforce

Give your teams the Power BI advantage

Empower your teams with the Microsoft Power BI advantage, discover insights hidden in your data and make confident business decisions with data.  

  • Discover your team's strengths and weaknesses 
  • Leverage Immersive Learning (with Cloud Labs) 
  • Measure skills progress with the right data 
  • Upskill your teams into modern roles with customized training solutions 

500+ Clients

Career Accelerator Bootcamps

Trending
Data Science Career Track Bootcamp
  • 140 hours of live and interactive sessions by industry experts
  • Immersive Learning with Guided Hands-on Exercises (Cloud Labs)
  • 140 Hrs
  • 4
BECOME A SKILLED DEVELOPER SKILL UP NOW
Front-End Development Bootcamp
  • 30 Hours of Live and Interactive Sessions by Industry Experts
  • Immersive Learning with Guided Hands-On Exercises (Cloud Labs)
  • 4.5
BECOME A SKILLED DEVELOPER SKILL UP NOW

Microsoft Power BI Course in Columbus, OH

Microsoft Power BI course in Columbus

As the state capital of Ohio, Columbus is also the most populous city of the state and among the fastest-growing cities in the US. The city has a diverse economy with industries like insurance, banking, defence, aviation, energy, hospitality having a strong foothold. Education, retail, technology and logistics further fuel the local economy. Having four Fortune 500 corporations with their headquarters in Columbus, the city remains the top choice for the ones looking for brighter career avenues. As professionals, one should always look for upgrading the skills. Joining the Microsoft Power BI certification in Columbus from KnowledgeHut Academy is a smart career move


About the Microsoft Power BI workshop in Columbus

Power BI is the best available tool for business analytics. You can analyze the data, gather valuable insights and visualize it effectively for business decision making. The dashboard provides you with a 360-degree view will all essential metrics in place. The Microsoft Power BI training in Columbus will develop you as a seasoned professional in the field of data analytics. Qualified tutors conduct the program in the online mode. You can contact the academy to get more information related to schedule, fee and the course structure. You can even enrol yourself for a free demo class.


Why should you take up the Microsoft Power BI course in Columbus?

The Power BI course is the best choice for the professionals looking to master data analytics and craft a career for themselves in this field. This 16 hours course has a curriculum devised, keeping in mind the industry requirements and special focus is on live projects and practical training. The candidates are trained on analyzing raw data from different source points vital for any organizations success. Practical training is provided on Power BI for Desktop, Power BI mobile app, server and gateway. The coaching covers all components of the Power BI solutions. Professionals from business development, marketing and sales functions and business analysts will be able to derive actionable insights after completion of this course.


The KnowledgeHut advantage for Microsoft Power BI Training

In this online course, your tutors are certified and experienced professionals drawn from the industry and academia. You are going to enrich from their knowledge and experience. You will have access to at least two live projects during the online training and 50 hrs of practical assignments. The course material is easily accessible online with lifelong support of all kinds from the academy support team. The study material is good support while preparing for various job interviews as well.


Are you keen to enhance your career opportunities? If yes, register for the Microsoft Power BI online training in Columbus today.


Other Training

For Corporates