#100daysofdawithdatakliq search results

#100daysofDAwithDatakliq #Estheroyenekan #Josephfadero #TobaMichaels #FolorunshoAjala #Pelumiarowosaye #Qowiyyoyesiji

Excel 101 Tip Named ranges > Absolute Referencing In my opinion. #ExcelTips365 #DataAnalytics #100daysofDAwithDataKliq #Excel #data

October was for learning SQL,coming back to quote this tweet on what I’ve been learning. Thanks to @DataKliq ,they are really instrumental to my tech growth. #SQL #100daysofDAwithDatakliq

In order to get grounded in #PowerBI I decided to jump on this report by @Adewaleanalyst. He explained some of the things that @folorunso_ajala has taught us in another way and really it was quite an interactive dashboard. #PowerBI #100daysofDAwithDatakliq

Still on Power BI training, and day 68 of #100daysofDAwithDatakliq.

The whole of September was for learning #PowerBI and really it was a real deal and yes it was not so challenging but it required time being my first encounter. Many thanks to @EstherOyenekan_ and @folorunso_ajala #100daysofDAwithDatakliq #PowerBI

Day 39-45: Started my powerBi learning with @DataKliq we started by learning #PowerBI interface How to get data into powerBi from file, #Excel , CSV Getting data from relational database, from online services @Datakliq #100daysofDAwithDatakliq @joseph_fadero @folorunso_ajala

Going forward in #PowerBI, our facilitator is doing a great job @folorunso_ajala he taught us the use of Calculated columns. we were introduced to Measures,implicit and explicit measures. #DAX was introduced also and various functions in Power BI #100daysofDAwithdatakliq

Power BI’s class started about 2weeks and we’ve been learning #dataExtraction,transformation, modeling and exploration.Thanks @EstherOyenekan_ and @folorunso_ajala for the well detailed class. #datakliq #100daysofDAwithDatakliq

Our tutors and facilitators are amazing. @joseph_fadero, @EstherOyenekan_ @Ajani_oyesiji,@folorunso_ajala #100DaysofDAwithDataKliq

Day 40 of #100DaysofDawithDatakliq with Data Kliq I learnt Data modeling in Power BI. The difference between Fact table and Dimension table was explained vividly with examples. I learnt about Star Schema and snowflake type of modeling.

Day 39 of #100DaysofDawithDatakliq with @DataKliq We learnt in debt Data Transformation and Analysis in Power BI with power query. #PowerBI @EstherOyenekan_ @folorunso_ajala @joseph_fadero @Pelumi_analyst @Ajani_oyesiji

Day 38 of #100DaysofDawithDatakliq with @DataKliq I learnt how to visualize Map on Pivot table. #EXCEL @joseph_fadero @EstherOyenekan_ @folorunso_ajala @Pelumi_Analyst @Ajani_oyesiji

Day 34-37 of #100DaysofDawithDatakliq with @DataKliq I learnt about the Power BI storage mode, The 3 types of Power BI storage modes where explained in detail by the facilitators. #PowerBI @folorunso_ajala @EstherOyenekan_ @joseph_fadero @Pelumi_Analyst @Ajani_oyesiji

Day 29- 33 of #100DaysofDawithDatakliq with @DataKliq Power BI was introduced. I learnt the Power BI building blocks. #PowerBI @EstherOyenekan_ @folorunso_ajala @joseph_fadero @Pelumi_Analyst @Ajani_oyesiji

Day 18-28 #100daysofDAwithDatakliq with @DataKliq I created a simple Dashboard from week 4 Assignment. @EstherOyenekan_ @joseph_fadero @Pelumi_Analyst @folorunso_ajala @Ajani_oyesiji

#100daysofDAwithDataKliq Final @DataKliq Microsoft Excel project, we were given a data set which mandated us to build a module & establish relationships between our facts & dimension table using star schema model. The visualization scheme was inspired by the organizations colors

Day 9: I did an exercise on data cleaning from what i learnt using Named Ranges, Text function, formula & formatting to cleaning & transform this data on excel👇open for correction. @DataKliq #100daysofDAwithDatakliq #DataFestAfrica2023 #data #DataFam #DataScience

#100daysofDAwithDataKliq Final @DataKliq Microsoft Excel project, we were given a data set which mandated us to build a module & establish relationships between our facts & dimension table using star schema model. The visualization scheme was inspired by the organizations colors

Day 10: I work on assignment giving to us by @DataKliq I was able to use the Logical Function in #Excel to solved the new salary column while i make use of Xlookup to populate the name, age & department👇 @DataKliq #100daysofDAwithDatakliq #DataFestAfrica2023 #data #DataFam

How to Wrap a Text Use the "Wrap Text" button Unwrapped Vs. Wrapped Text Day 6 #100daysofDAwithDatakliq @DataKliq

Day 14 of #100DaysofDawithDatakliq with @DataKliq I was able to clean this dirty data to this using Power query. #DataAnalytics @EstherOyenekan_ @joseph_fadero @folorunso_ajala @Pelumi_Analyst @Ajani_oyesiji

Workbook Vs. Worksheet I will save this for a future interview session #Excel Workbook #100daysofDAwithDatakliq Day 5 @DataKliq

#100daysofDAwithDatakliq #Estheroyenekan #Josephfadero #TobaMichaels #FolorunshoAjala #Pelumiarowosaye #Qowiyyoyesiji

Day 12-19: I did data cleaning on different dataset, rewatch various lesson on power query & pivot table from @Datakliq @wisabiHQ @Alex_TheAnalyst @SimonSezIT finally completed an assignment wk3 from @DataKliq #100daysofDAwithDatakliq #DataFestAfrica2023 #data #DataAnalytics 👇

Day 18-28 #100daysofDAwithDatakliq with @DataKliq I created a simple Dashboard from week 4 Assignment. @EstherOyenekan_ @joseph_fadero @Pelumi_Analyst @folorunso_ajala @Ajani_oyesiji

Day 20 of #100DaysofDAwithdatakliq I used Power query in Cleaning Data and the data came out much better than the old one. I'm so happy to be doing this. Cheers to more🥂 @Datakliq

Day 9: Practiced using VLOOKUP and the IF function. #100DaysofDAwithDatakliq

Day 7: Practiced Splitting text and case changing #100DaysofDAwithDatakliq

An assignment was given by @DataKliq and because @joseph_fadero already taught us flash fill,In minutes the assignment was done. Omo technology sweet o 😊 ,as I Dey press the function,the flash fill was flash filling,my heart dey sweet me😎 #100daysofDAwithDatakliq #Excel #day7

Still on Power BI training, and day 68 of #100daysofDAwithDatakliq.

We started our cohort 3 training last weekend with that we commenced a daily learning challenge for the participants. For this challenge we have rewards such as branded swags and ticket to @DataFestAfrica #100daysofDAwithDatakliq #datafest

@Datakliq on day 17 of #100daysofDAwithdatakliq I called up the almighty cleaning tool- Power query to clean a very dirty data. Still in the process of cleaning hoping to get the better of the data like every other data analyst🤲

Day 15 of #100DaysofDawithDatakliq with @DataKliq I solved my week 3 assignment. From the 3 attached documents was the dirty data which I cleaned with Power query and used the data to answer the questions on the last document. Once the answer is right, the smileys will smile.

On day 15 of #100daysofDAwithdatakliq I got my hands on lookup functions assignment. Its feeling of solving the task after several hours was joyous 😆😆@datakliq thanks

Day 4: Today I was introduced types and scales of data by watching @starboy_abefe’s videos. Looking forward to learning more on my journey. #100DaysofDAwithDatakliq

Day 3: I learnt how to use flash fill and how to create a calendar using the SEQUENCE function. #100DaysofDAwithDatakliq