Day 5 of My 108-Day Data Analytics Challenge: Today’s focus was on strengthening my understanding of SQL, Tableau, and Python. Here’s what I accomplished: ➡ SQL: • Focused on core SQL commands like `SELECT`, `DISTINCT`, and `COUNT`. These are essential for querying databases and retrieving meaningful insights. I’m starting to see how SQL forms the backbone of data manipulation. • I’m also keeping detailed notes on SQL concepts, which I’ll be sharing soon to help others who are learning alongside me. ➡ Tableau: • Today was all about combining data in Tableau. I learned the different methods such as Joins, Unions, Relationships, and Data Blending, which are critical for integrating multiple datasets into cohesive visualizations. • I also explored the logical & physical layers in data modeling—helping me better understand how to structure data efficiently. ➡ Python (Numpy): • Continued my journey with Numpy by diving deeper into array manipulations. Learned array transposition, universal array functions, and efficient data processing techniques using arrays. • Also covered input/output operations for arrays, which is key for storing and retrieving data during analysis. #DataAnalytics #SQL #Tableau #Python #Numpy #DataVisualization #LearningJourney #DataScience #TechSkills #ContinuousLearning #BusinessIntelligence #DataModeling #DatabaseManagement #GrowthMindset #108DayChallenge
Pankaj Tholia’s Post
More Relevant Posts
-
Data Analytics Skills That Give the Biggest ROI: → SQL → Python → Excel → Tableau → Power BI → Data Cleaning → Data Visualization → Data Transformation Free resources to learn these skills. SQL - https://lnkd.in/gQkjdAWP Python - https://lnkd.in/gQk8siKn Excel - https://lnkd.in/d-txjPJn Power BI - https://lnkd.in/gs6RgH2m Data Cleaning - https://lnkd.in/dCXspR4p Data Visualization - https://lnkd.in/dcHqhgn4 Books - https://lnkd.in/dmuznBwK Projects - https://t.me/sqlproject Best Resources to Prepare for Interviews - https://lnkd.in/dF2KKWBY
To view or add a comment, sign in
-
📊 3 Key Skills Every Aspiring Data Analyst Should Focus On: 1️⃣ SQL Mastery : SQL is the backbone of data querying. Whether it's retrieving, updating, or analyzing data, SQL lets you interact with databases efficiently. Start with the basics, then dive into advanced queries like JOINS, subqueries, and window functions. 2️⃣ Data Visualization : Turning raw data into meaningful visuals is critical for communicating insights. Tools like Power BI or Tableau help create intuitive, interactive dashboards that bring data stories to life. 3️⃣ Python for Data: From data cleaning to machine learning, Python has a wide range of libraries like Pandas, NumPy, and Matplotlib. It’s a powerful tool to automate tasks and deepen your analysis. 🌟 Focus on these skills to build a strong foundation and thrive in the data world! #DataAnalytics #LearningWithData #DataSkills #SQL #PowerBI #Python
To view or add a comment, sign in
-
Run #R Script in #tableau In the previous blogs, I wrote how to run the Python script in Tableau. Python is very helpful when we need to solve complex problems; especially when we need to forecast data, build data models, and return results to visualize in Tableau. For statistical data, R is one of the best languages if the user wants to work with statistical values. For some complex problems such as ANOVA, T-test, normality test, regression, and forecasting data, it's hard to build calculations in Tableau. But we can run the R script in Tableau Prep Builder or Tableau Desktop and return the statistical values we want. In my latest blog, I wrote how to install, load packages, and run Rserve in the R Console. I also shared how to connect Rserve on Tableau Prep Builder and Tableau Desktop. In the next blog, I am going to share the data structure when we input/output data from the R script to run in Tableau. I hope my blogs are helpful to you. Run R script in Tableau - part 1: https://lnkd.in/de8Kh4uz Python in Tableau - part 1: https://lnkd.in/dWmN4A4K Python in Tableau - part 2: https://lnkd.in/dK2apstz #statistics #statistical analytics
To view or add a comment, sign in
-
Hi Folks, I have completed a Data Analyst certification from ExcelR, further strengthening my expertise in SQL, Data analysis Python, PowerBI,Tableau and Excel, I excel at transforming complex data into actionable insights to support strategic decision-making. #DataAnalyst #DataAnalysis #ExcelR #SQL #Python #Tableau #DataScience #Analytics #ProfessionalDevelopment #Certification #LTIMindtree
To view or add a comment, sign in
-
Beginner’s Guide: Must-Know Interview Questions for Beginners SQL Server 1. What are the different types of joins in SQL, and when would you use each? 2. How do you optimize a SQL query for better performance? 3. What is the purpose of indexing in SQL databases? Excel 1. How do you perform a VLOOKUP and HLOOKUP in Excel? 2. What are pivot tables, and how do you create and use them? 3. How do you use conditional formatting in Excel to highlight important data? Power BI 1. How do you create a calculated column and a measure in Power BI, and what are the differences between them? 2. What is DAX, and how do you use it for advanced calculations in Power BI? 3. How do you set up and use Power BI dashboards to monitor key metrics? Python 1. How do you read and write data from/to different file formats in Python (e.g., CSV, JSON)? 2. What are lambda functions in Python, and when should you use them? 3. How do you use libraries like pandas and NumPy for data analysis in Python? Data Visualization 1. How do you tell a compelling story with your data visualizations? 2. What are the differences between exploratory and explanatory data visualization? 3. How do you design a dashboard that is both informative and user-friendly? Follow for more Priyanka SG #Excel #SQL #PowerBI #Python #Dataanalyst
To view or add a comment, sign in
-
My bread and butter are SQL, Python, and Tableau. I'm confident that I can do most things that require of me on a project. And it's not only because I know the tools, but I'm also familiar with the concepts and knowledge associated with them. Things like ETL, data viz, and data modelling. It's like the 80/20 rule. You get very good at a few things and everything else will follow. Focus on what matters and keep expanding on your knowledge and skills. #python #sql #tableau #datamodeling #skills #dataviz #knowledge
To view or add a comment, sign in
-
I’m excited to share that I just completed The Complete Data Visualization Course, which covers Python, R, Tableau, and Excel. This is a comprehensive course that has transformed me into a proficient data visualization specialist. I initially had problems with connecting data insights to compelling visualizations. However, courtesy of the interactive lessons, hands-on projects, and expert guidance, I have mastered the various tools and techniques. I gained expertise in Python libraries like Matplotlib and Seaborn, R's ggplot2, Tableau's data storytelling, and Excel's Power Query and Power Pivot. The course laid emphasis on data manipulation, visualization best practices, and effective communication. The Real-world projects helped solidify concepts, allowing me to apply all my learnings to practical scenarios. Now, I confidently craft interactive visualizations, uncover hidden trends, and drive business decisions. This course exceeded my expectations, has opened doors to new career opportunities and enhanced my analytical skills. I highly recommend it to anyone seeking to unlock the power of data visualization. #Learn365
To view or add a comment, sign in
-
🔍 Navigating the Data Analysis Toolkit: Tableau, Excel, or Python? 🔎 In the ever-expanding universe of data analysis, the choice of tool can make all the difference. Whether you're dissecting data for insightful visualizations, crunching numbers for business forecasts, or delving into predictive analytics, the key lies in selecting the right instrument for the task at hand. 📊 Tableau: Your go-to for crafting story-driven, interactive dashboards that speak volumes. Its intuitive interface opens the doors to complex visualizations, making data not just seen but experienced. 📈 Excel: The venerable Swiss Army knife of data manipulation and analysis. From spreadsheets to pivot tables, Excel's familiar grid layout and formula-based environment make it indispensable for quick analyses and financial modeling. 🐍 Python: The powerhouse of data science. With libraries like Pandas and NumPy, Python transcends traditional analysis, offering scalable solutions from data preprocessing to machine learning, all within a cohesive coding environment. Each tool has its stage, its moment where it shines brightest, determined by the nature of your data, the scale of your project, and the audience for your insights. 🤔 Have you found yourself at a crossroads, choosing between these tools? Share your experiences, tips, or questions below. Let's demystify the path to data enlightenment together! #DataAnalysis #Tableau #Excel #Python #DataScience #BusinessIntelligence
To view or add a comment, sign in
-
Exploring key skills and tools in Business Data Analytics to drive data-driven insights and strategic decisions. #BusinessDataAnalytics #DataVisualization #SQL #Python #PowerBI #Tableau #Excel #DataCleaning #PredictiveAnalytics #GoogleAnalytics #MachineLearning #KPI #Dashboard #DataMining #BusinessIntelligence #BigData #DataAnalysis #SentimentAnalysis #DataDrivenDecisions #DataTrends
To view or add a comment, sign in
-
💥75 DAYS CHALLENGE -- DATA SCIENCE DAY 45/75 POWER BI--BASICS 🛠 INTEGRATING R AND PYTHON IN POWER-BI Integrating R and Python scripts in Power BI can greatly enhance your data analysis and visualization capabilities. 🔰 USING R SCRIPTS IN POWER BI 📌 Install R: Ensure R is installed on your machine. You can download it from the CRAN website. 📌 Enable R Scripting: 🍭 Open Power BI Desktop. 🍭 Go to File > Options and settings > Options > R scripting. 🍭 Provide the path to your R installation. 📌 Create and Run R Scripts: 🍭 Go to Home > Get data > More > Other > R script. 🍭 Write your R script to import and transform your data. 🍭 Click OK, and Power BI will execute the script and display the resulting data in the Power Query Editor. 🔰 USING PYTHON SCRIPTS IN POWER BI 📌 Install Python: Download and install Python from the official Python website. 📌 Enable Python Scripting: 🍭 Open Power BI Desktop. 🍭 Go to File > Options and settings > Options > Python scripting. 🍭 Provide the path to your Python installation. 📌 Create and Run Python Scripts: 🍭 Go to Home > Get data > More > Other > Python script. 🍭 Write your Python script to import and transform your data. 🍭 Click OK, and Power BI will execute the script and display the resulting data in the Power Query Editor. #75_Days_Challenge #Powerbi #PowerbiDashboard #PythoninPowerbi #RinPowerbi #excel #data_science #DataScience #DataAnalysis #DataAnalytics #BigData #DataVisualization #DataDriven #DataInsights #Analytics #entri_elevate #75DaysOfDataAnalysisChallenge Dr.Jitha P Nair
To view or add a comment, sign in