Introduction

0:07 Hey everyone, welcome to PowerB course by Sinclair. In today's datadriven world, business analytics is the key to making smarter decisions and advancing your career. So whether you're a beginner or have some experience, this course will help you develop the skills to master business analytics. As industries increasingly rely on data, the ability to analyze and visualize insights has become essential. You learn how to create impactful visualizations, perform statistical analysis, and apply predictive modeling all while gaining hands-on experience with tools like PowerBI, Excel, Tableau, and Python.

0:31 And by the end, you'll be confident turning raw data into valuable insights. Also, if you are interested in becoming a business analyst, Simple Learn offers the perfect certification program to help you achieve your goals. So, with this course, you'll learn how to solve complex business problems and gain essential skills all aligned with IIBA, Babok, B3 standards, including CBA and CCBA certifications. Plus, you'll master tools like Tableau, SQL, Excel, and even cutting edge Geni tools like Chad, GPT, Dali 2, Gemini, and Mid Journey.

0:53 So hurry up and enroll 9finder course link in the description box below and in the pin comments. It is no surprise that business analytics and business intelligence are two of the fastest growing markets in the world. Organizations today are generating data at a rapid rate. There is a need to use this business data and make smarter decisions. Companies are looking for methods and tools to turn business data into actionable insights. This is where business analytics and intelligence can help play a critical role.

1:38 Business analytics is the process of collecting, analyzing and drawing valuable conclusions from vast volumes of data available. It helps to improve business performance through fact-based decision making. On the other hand, business intelligence or BI is a technology that enables data preparation, data mining, data management and data visualization. It allows you to analyze data with queries and create reports and dashboards with the help of charts and graphs to be used by business leaders. Business analytics and business intelligence together create capabilities for companies to compete in the market effectively.

2:01 Consider this example. Suppose you sell homemade chocolates through an online store. Business intelligence provides meaningful insights into the past and current state of your business. BI tells you that sales of your milk chocolate have spiked up in Texas the past 2 weeks. So you decide to manufacture more milk chocolates to keep up with demand. Business Analytics asks, "Why did sales of milk chocolate spike up in Texas?" By scrutinizing your website data, you learned that most traffic has come from a post by a food blogger based in Texas who liked your milk chocolate.

2:23 This insight helps you decide to send complimentary chocolates to a few other well-known food bloggers throughout the United States. Using cuttingedge business analytics and intelligence tools such as Microsoft Excel, SQL, PowerBI and Tableau can enhance customer experience, improve efficiency, conduct competitor analysis, and accelerate growth. With this basic knowledge of business analytics and business intelligence, let's look at the topics we'll be covering in this video. We will start with learning the need for business analytics and the responsibilities of a business analyst.

3:11 Then we will look at the top business analytics skills and learn about business analytics and intelligence with Microsoft Excel. After that we will see the basics of business intelligence and get an idea about agile and scrum methodologies. Next we will learn to create reports and dashboards in Microsoft Excel and understand in detail how to visualize data with top business intelligence tools such as PowerBI and Tableau. Let's get started. We will understand the importance of business analyst with a short and interesting story.

3:33 So meet Rob. He runs a cafe in a small town far away. His cafe is one of the oldest and most popular eeries in town. Rob's cafe was hugely popular amongst customers and it was doing very well until the onset of the deadly corona virus. Due to COVID 19, like other eeries, Rob was forced to shut down his cafe too. This took a heavy toll on his business and subsequently he lost his customers. None of his customers visited his cafe and this resulted in a huge loss for him.

3:57 He knew he couldn't afford to close his business forever as it would take time for corona virus to be eradicated. But he was lost. This situation was new to him and he didn't know how to reopen his business amidst this pandemic. After a lot of brainstorming, he recollected reading about business analysts. He remembered that business analysts are professionals who enable a change in an organization. He felt like a business analyst could help him sort out his current business problems.

4:43 Hence, without wasting any time, he set out to hire a business analyst. He hired Ted, the business analyst, to help him with his ongoing business problems. Rob entrusted Ted with reopening the business. The first step Ted took was to have a discussion with Rob and understand the business problems and the objectives. That is ideally the first step a business analyst would take. On discussing with Rob, Ted learned that the business objective was to reopen the business and get at least 80% of the customer base back.

5:06 In addition to that, Rob also wanted Ted to look for sustainable ways to reopen and continue the business in the long run amidst the pandemic. Ted studied the case and he came up with a few suggestions that he thought was fit for Rob's business. His first suggestion was to develop an exclusive home delivery app for Rob's cafe. This way, Ted knew that business will improve as customers prefer home delivery in the current scenario. Next, Ted suggested that Rob has work from home meal boxes added to his menu.

5:31 Many professionals are working from home currently, and having work