☺️ Need your help for Heroku ☁️


☁️ Heroku add 1$ verification process for Adding CC so it's impossible to add fake cc now.

✔️ But we can do one thing, let's started tweet about it on Twitter(X)

🏇 Do these steps:

1) Download & Signup Twitter (X) ✅

2) Copy this message: ✅

👉 Dear @heroku & @Salesforce, as students, we depend on your platform to learn, innovate, and build our dreams. The $1 verification is a significant barrier for many of us who don't have credit cards. Please bring back the free tier and support the future of tech.

#BringBackHerokuFreePlans #SupportStudents #Heroku #Salesforce
#free_heroku_for_student
#heroku
#remove_cc_for_student

5) Reply to that tweet by pasting the message you copied and saved. Or Tweet yourself 😉

Interview Question:

1. Which type of chart will you use to compare and show the sales by region in Power BI?

Answer:

To compare and show the sales by region in Power BI, a bar chart or column chart is typically used. These charts are effective for comparing data across different categories, such as regions, and they clearly display differences in sales values.

Sample Dataset:

| Region | Quarter | Product | Sales |
|---------|---------|----------|-------|
| North | Q1 | Product A| 50000 |
| North | Q1 | Product B| 30000 |
| North | Q2 | Product A| 40000 |
| North | Q2 | Product B| 35000 |
| South | Q1 | Product A| 45000 |
| South | Q1 | Product B| 25000 |
| South | Q2 | Product A| 30000 |
| South | Q2 | Product B| 32000 |
| East | Q1 | Product A| 42000 |
| East | Q1 | Product B| 28000 |
| East | Q2 | Product A| 39000 |
| East | Q2 | Product B| 31000 |
| West | Q1 | Product A| 41000 |
| West | Q1 | Product B| 29000 |
| West | Q2 | Product A| 35000 |
| West | Q2 | Product B| 29000 |
| Central | Q1 | Product A| 48000 |
| Central | Q1 | Product B| 32000 |
| Central | Q2 | Product A| 43000 |
| Central | Q2 | Product B| 31000 |

Steps to Visualize in Power BI:

1. Import the Dataset:
- Open Power BI Desktop.
- Import the dataset into Power BI.

2. Create the Bar Chart:
- In the Fields pane, select the fields Region, Quarter, Product, and Sales.
- From the Visualizations pane, select the Clustered Bar Chart or Stacked Bar Chart icon.

3. Configure the Chart:
- Drag Region to the Axis field well.
- Drag Sales to the Values field well.
- Drag Quarter and Product to the Legend or Small Multiples field well to add additional dimensions.

4. Customize the Chart:
- Add data labels to show the exact sales figures.
- Adjust colors and styles to improve readability.
- Use filters or slicers to focus on specific regions, quarters, or products if needed.

Answer Explanation:
A bar chart or column chart with additional dimensions like Quarter and Product allows for a more detailed comparison of sales by region. You can see not only the total sales per region but also how each product performs across different quarters within each region.

### Additional Interview Questions:

2. How can you create a calculated column in Power BI to show the profit margin percentage?

Answer:

To create a calculated column in Power BI to show the profit margin percentage, follow these steps:

1. Go to the Data view in Power BI Desktop.
2. Select the table where you want to create the new column.
3. Click on the New Column button in the Modeling tab.
4. Enter the formula for the calculated column. For example:
Profit Margin = (Sales - Cost) / Sales * 100
5. Press Enter.

This will create a new column in your table showing the profit margin percentage for each row.

3. What is the difference between a measure and a calculated column in Power BI?

Answer:

The key difference between a measure and a calculated column in Power BI is how and when they are calculated and used:

- A calculated column is calculated row by row when the data is loaded into the data model. It is stored in the table and can be used like any other column in the table.
- A measure, on the other hand, is calculated on the fly based on the context of the visualization. Measures are typically used for aggregations, such as sums, averages, or counts, and they are not stored in the table but are recalculated as needed.

4. How would you handle a situation where your Power BI report is performing slowly?

Answer:

To handle a situation where a Power BI report is performing slowly, you can:

1. Optimize your data model by removing unnecessary columns and tables.

2. Use relationships and filtering carefully to minimize the amount of data processed.
3. Avoid using complex DAX calculations in visuals; instead, create calculated columns or tables if needed.
4. Use aggregate tables or pre-aggregated data to reduce the volume of data processed in visuals.
5. Ensure that your data source is optimized for performance, such as indexing important columns or partitioning large tables.
6. Use Power BI Performance Analyzer to identify and troubleshoot performance bottlenecks in your report.

𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐑𝐞𝐚𝐥 𝐓𝐢𝐦𝐞 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐒𝐞𝐫𝐢𝐞𝐬 📊

𝐃𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐜𝐞 𝐛𝐞𝐭𝐰𝐞𝐞𝐧 𝐑𝐞𝐩𝐨𝐫𝐭𝐬 𝐯𝐬 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝𝐬

𝐑𝐞𝐩𝐨𝐫𝐭:
𝐖𝐡𝐞𝐫𝐞 𝐲𝐨𝐮 𝐦𝐚𝐤𝐞 𝐢𝐭: Power BI Desktop,
𝐖𝐡𝐚𝐭 𝐢𝐭 𝐬𝐡𝐨𝐰𝐬: Reports in Power BI are detailed documents that use charts, graphs, and tables to explain your data. They help you analyze trends and find insights.

𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝:
𝐖𝐡𝐞𝐫𝐞 𝐲𝐨𝐮 𝐦𝐚𝐤𝐞 𝐢𝐭: Power BI service
𝐖𝐡𝐚𝐭 𝐢𝐭 𝐬𝐡𝐨𝐰𝐬: Dashboards is a display of key metrics and KPIs from multiple reports. They give you a quick overview of your data.

𝐘𝐨𝐮 𝐜𝐚𝐧 𝐬𝐞𝐥𝐞𝐜𝐭 𝐯𝐢𝐬𝐮𝐚𝐥𝐬 𝐟𝐫𝐨𝐦 𝐦𝐮𝐥𝐭𝐢𝐩𝐥𝐞 𝐫𝐞𝐩𝐨𝐫𝐭𝐬 𝐭𝐨 𝐜𝐫𝐞𝐚𝐭𝐞 𝐚 𝐬𝐢𝐧𝐠𝐥𝐞 𝐝𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝.

Frontend: HTML, CSS, JavaScript, React

Backend: Python, Node.Js, Ruby, Java, API

Database: Mysql, MongoDB, Oracle, PostgreSQL

Cloud: AWS, Azure, Google Cloud, Digital Ocean

UI/UX: Figma, Adobe XD, Visual Studio, Git

*You can learn ReactJS easily 🤩*

Here's all you need to get started 🙌

1.Components
• Functional Components
• Class Components
• JSX (JavaScript XML) Syntax

2.Props (Properties)
• Passing Props
• Default Props
• Prop Types

3.State
• useState Hook
• Class Component State
• Immutable State

4.Lifecycle Methods (Class Components)
• componentDidMount
• componentDidUpdate
• componentWillUnmount

5.Hooks (Functional Components)
• useState
• useEffect
• useContext
• useReducer
• useCallback
• useMemo
• useRef
• useImperativeHandle
• useLayoutEffect

6.Event Handling
• Handling Events in Functional Components
• Handling Events in Class Components

7.Conditional Rendering
• if Statements
• Ternary Operators
• Logical && Operator

8.Lists and Keys
• Rendering Lists
• Keys in React Lists

9.Component Composition
• Reusing Components
• Children Props
• Composition vs Inheritance

10.Higher-Order Components (HOC)
• Creating HOCs
• Using HOCs for Reusability

11.Render Props
• Using Render Props Pattern

12.React Router
• <BrowserRouter>
• <Route>
• <Link>
• <Switch>
• Route Parameters

13.Navigation
• useHistory Hook
• useLocation Hook

State Management

14.Context API
• Creating Context
• useContext Hook

15.Redux
• Actions
• Reducers
• Store
• connect Function (React-Redux)

16.Forms
• Handling Form Data
• Controlled Components
• Uncontrolled Components

17.Side Effects
• useEffect for Data Fetching
• useEffect Cleanup

18.AJAX Requests
• Fetch API
• Axios Library

Error Handling

19.Error Boundaries
• componentDidCatch (Class Components)
• ErrorBoundary Component (Functional
Components)

20.Testing
• Jest Testing Framework
• React Testing Library

21. Best Practices
• Code Splitting
• PureComponent and React.memo
• Avoiding Reconciliation
• Keys for Dynamic Lists

22.Optimization
• Memoization
• Profiling and Performance Monitoring

23. Build and Deployment
• Create React App (CRA)
• Production Builds
• Deployment Strategies

Frameworks and Libraries

24.Styling Libraries
• Styled-components
• CSS Modules

25.State Management Libraries
• Redux
• MobX

26.Routing Libraries
• React Router
• Reach Router

Basic web development roadmap
🟧
1.Learn: How websites work, front-end vs back-end, code editor‌‌
🟧
2: Basic front-end:
a. Html
b. Css
c. Javascript
Expected time 7+14+30=51 days.
🟧
3. Learn front-end frameworks:
a. Learn css framework ( Bootstrap , Tailwind css , ...)
b. Learn JavaScript frameworks ( angular, react , vue...)

Expected time minimum 60 days.
🟧
4. Learn database
a. MySQL
b. MongoDB
There are many more. Choose one and learn.
🟧
5. Learn backend programming languages:
a. Php
b. Nodejs
There are many more. Learn any one.

Expected time: 60 days
🟧
6. Do some projects and clone some websites.
▫️▫️🟧▫️▫️

Here's a short roadmap to crack an IT job with a non-CS background 🚀

1. 📚 Learn basics of CS and programming.
2. 🎯 Choose a specialization (e.g., web dev, data analysis).
3. 🏆 Complete online courses and certifications.
4. 🛠️ Build a portfolio of projects.
5. 🤝 Network with professionals.
6. 💼 Seek internships for experience.
7. 📚 Keep learning and stay updated.
8. 🧠 Develop soft skills.
9. 📝 Prepare for interviews.
10. 💪 Stay persistent and positive! Good luck!

𝗚𝗶𝘁 𝘃𝘀 𝗚𝗶𝘁𝗛𝘂𝗯: What's the Difference?

Ever mixed up Git and GitHub? You’re not alone—they’re related but serve distinct purposes!

𝐆𝐢𝐭: A powerful version control system that tracks changes in your code. It’s your local toolkit for managing versions, rolling back changes, and collaborating.

𝐆𝐢𝐭𝐇𝐮𝐛: A cloud-based platform that hosts Git repositories online. It enhances collaboration by letting you share, review, and manage code—think of it as a social network for developers.

In short:
Git = Local version control tool
GitHub = Cloud-based hosting service for Git repositories

Understanding the difference can significantly improve your workflow and collaboration in software development!

What Is MERN?

MERN Stack is a Javascript Stack that is used for easier and faster deployment of full-stack web applications. MERN Stack comprises of 4 technologies namely: MongoDB, Express, React and Node.js. It is designed to make the development process smoother and easier.

MongoDB

MongoDb is a NoSQL DBMS where data is stored in the form of documents having key-value pairs similar to JSON objects. MongoDB enables users to create databases, schemas and tables.

ExpressJS

ExpressJS is a NodeJS framework that simplifies writing the backend code. It saves you from creating multiple Node modules.



ReactJS

ReactJS is a JS library that allows the development of user interfaces for mobile apps and SPAs. It allows you to code Javascript and develop UI components.

NodeJS

NodeJS is an open-source Javascript runtime environment that allows users to run code on the server.

How Git Works - From Working Directory to Remote Repository

[1]. Working Directory:
Your project starts here. The working directory is where you actively make changes to your files.
[2]. Staging Area (Index):
After modifying files, use git add to stage changes. This prepares them for the next commit, acting as a checkpoint.
[3]. Local Repository:
Upon staging, execute git commit to record changes in the local repository. Commits create snapshots of your project at specific points.
[4]. Stash (Optional):
If needed, use git stash to temporarily save changes without committing. Useful when switching branches or performing other tasks.
[5]. Remote Repository:
The remote repository, hosted on platforms like GitHub, is a version of your project accessible to others. Use git push to send local commits and git pull to fetch remote changes.
[6]. Remote Branch Tracking:
Local branches can be set to track corresponding branches on the remote. This eases synchronization with git pull or git push.