Power BI with SQL and Excel: Connecting Data Sources and Building Reports (Episode 9) (Updated May 2026)

TCS announced 12,000 layoffs in July 2025, with data analytics skills cited as the primary differentiator for those who stayed. The good news is — Power BI combined with SQL Server and Excel is the exact trifecta that hiring managers at Infosys, TCS, and Wipro look for when they open a data analyst role. In Episode 9 of our Power BI series, we go beyond drag-and-drop visuals and connect to real SQL Server databases, join tables with relationships, write DAX measures, and build a report that your manager can actually use to make decisions. This is the episode where Power BI stops being a toy and starts being a career tool.

▶ Watch on YouTube

Why Power BI + SQL + Excel Is the Data Analyst Trifecta in India

TCS announced 12,000 layoffs in July 2025. NASSCOM and Deloitte project that 1.25 million AI and data-fluent professionals will be needed in India by 2027. These two data points tell the same story from opposite directions: routine IT jobs are shrinking, while analytical and data visualisation roles are growing faster than the talent pool. Power BI, SQL Server, and Excel is the specific combination that appears in 73% of data analyst job descriptions on Naukri India (as of Q1 2025). SQL gives you the ability to query and join enterprise databases; Excel is the data cleaning and modelling layer most Indian businesses still rely on; Power BI is the presentation layer that turns numbers into decisions. Infosys, TCS, Wipro, HCL and every mid-size IT company in Pune's Hinjewadi, Magarpatta and Kharadi corridors hire Power BI analysts with SQL proficiency. The pay gap is significant: a Power BI developer with SQL skills earns ₹5–8 LPA versus ₹3.5–4.5 LPA for someone who only knows Excel. That gap justifies the training investment many times over.

Connecting Power BI to SQL Server: Step-by-Step

To connect Power BI Desktop to SQL Server, go to Home > Get Data > SQL Server. Enter the server name (or IP address and port), select DirectQuery or Import mode, and choose your target database. For most analysis work, Import mode is faster — Power BI caches the data in its in-memory engine. DirectQuery is better when your dataset exceeds 1 GB or when you need real-time data from a live ERP like SAP or Oracle. Once connected, Power Query Editor opens and shows your tables. You can select multiple tables — for example, Sales, Products, and Customers — and load them all in one step. The Navigator pane previews each table's data before you import. After loading, go to Model view and draw relationships between tables using foreign keys: Sales[ProductID] to Products[ProductID], Sales[CustomerID] to Customers[CustomerID]. This is the data model that every subsequent DAX measure and visual will query. Getting the data model right before building visuals saves enormous rework time.

Using Excel as a Power BI Data Source and When to Avoid It

Excel is still the most common data source for Power BI in Indian SMEs and mid-size companies because most of their historical data lives in .xlsx files. To connect, use Get Data > Excel Workbook. Power BI detects sheets and named Tables — always structure your Excel data as a named Table (Ctrl+T in Excel) before connecting, not as a plain range. This makes the connection robust when the Excel file grows. The trust me moment here: do not leave your Excel source file on a local drive and expect the Power BI report to refresh correctly when shared. Always place the Excel file in OneDrive for Business or SharePoint so scheduled refresh works in Power BI Service. For heavy data — more than 100,000 rows — migrate from Excel to SQL Server first and then connect Power BI to SQL. Excel was not designed as a database and Power BI will punish you with slow performance if you try to use it as one.

Writing Your First DAX Measures: CALCULATE, SUMX and RELATED

DAX (Data Analysis Expressions) is what separates a Power BI user from a Power BI analyst. The three measures you must master first are: CALCULATE — which changes the filter context of any expression, letting you compute year-to-date sales, same-period-last-year comparisons, or filtered totals; SUMX — an iterator that sums an expression row by row across a table, essential for computing margin, weighted averages, or conditional totals; and RELATED — which fetches a column from a related table, used when your fact table needs an attribute from a dimension table. A simple example: Total Margin = SUMX(Sales, Sales[Quantity] * RELATED(Products[SellingPrice]) - Sales[Quantity] * RELATED(Products[CostPrice])). This single measure replaces six Excel columns and updates automatically when the data refreshes. Once you understand filter context and row context, every other DAX function becomes intuitive. This is the lesson that separates candidates who get data analyst interviews from those who don't.

Building an Interactive Sales Dashboard in Power BI

A practical sales dashboard in Power BI has six core visuals: a Card visual showing Total Revenue, a Card showing Total Margin %, a Bar Chart of Revenue by Region, a Line Chart of Monthly Trend, a Matrix (pivot table equivalent) of Product Category × Month performance, and a Slicer for filtering by time period or sales rep. The key principle for interaction: every visual should cross-filter every other visual when clicked. Set this up via Format > Edit Interactions — change any visual that should not filter to None instead of Filter. Use a date table (CALENDARAUTO or a custom DimDate table) linked to your transactions table to enable time intelligence functions like TOTALYTD and SAMEPERIODLASTYEAR. Colour conventions matter: keep backgrounds white, use the company's brand colours for bars, and never put dark text on dark backgrounds. Dark-on-dark text is a presentation failure. Export the finished report as a PBIX file and publish it to Power BI Service for sharing — covered in Episode 8.

Power BI Careers in India: Salaries, Companies and How to Get Hired

Power BI analyst salaries in India's IT hubs: Glassdoor India (2025) shows ₹4.5–7 LPA for a Power BI Analyst with 0–2 years experience, ₹7–12 LPA for 3–5 years, and ₹12–18 LPA for a Power BI Developer with Azure and SQL Server expertise. In Pune specifically — Infosys Pune (Hinjewadi), TCS STP Pune (Rajiv Gandhi Infotech Park), Wipro Pune (Kharadi), Cognizant Pune (Mundhwa), and Accenture Pune (Magarpatta) are the five largest recruiters of Power BI professionals. For Sambhajinagar engineers, IT companies at Aurangabad IT Park (N-7, CIDCO) and Tech Mahindra MIDC Chikalthana post Power BI roles quarterly. ABC Trainings' Power BI + SQL + Excel program runs at all five centers and includes a live project component where you build a real dashboard from a company dataset. This project becomes your portfolio piece for the interview. Students eligible for Maharashtra's CMYKPY scheme (₹6,000–₹10,000 stipend) should ask our counselor at enrollment. Call 7039169629 to check current batch schedule.

FAQs

Do I need to know SQL before learning Power BI?

You do not need prior SQL knowledge to start learning Power BI, but knowing SQL significantly increases your job prospects and salary range. ABC Trainings teaches SQL Server alongside Power BI in the same program so you develop both skills together. Most Indian companies expect data analysts to be able to write basic SELECT and JOIN queries.

What is the difference between Power BI DirectQuery and Import mode?

Import mode downloads data into Power BI's in-memory engine — reports load fast and work offline. DirectQuery sends live queries to the source database each time a visual updates — best for large datasets above 1 GB or when real-time data is needed (e.g. live ERP). For most analyst roles in Indian IT companies, Import mode with scheduled refresh covers 90% of use cases.

What salary can a Power BI analyst expect in Pune in 2025?

According to Glassdoor India (2025), a Power BI Analyst with 0–2 years experience earns ₹4.5–7 LPA in Pune. With 3–5 years and SQL Server skills the range rises to ₹7–12 LPA. Top recruiters include Infosys (Hinjewadi), TCS (Rajiv Gandhi IT Park), Wipro (Kharadi) and Accenture (Magarpatta).

Does ABC Trainings offer a combined Power BI, SQL and Excel course?

Yes — ABC Trainings' AI Powered Application Development workshop covers Excel, SQL Server, Power BI Desktop and Power BI Service in an integrated curriculum. Students build a live project dashboard as their portfolio piece. Batches run at Wagholi, Hadapsar, Cidco, Osmanpura and Sangli. Call 7039169629 for the current schedule.